﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using AspNetCs.Model;

namespace AspNetCs.IDAL
{
    public interface IAncestralHallItems
    {
        /// <summary>
        /// 添加宗祠版块
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        int Add(AncestralHallItems_Model model);

        /// <summary>
        /// 修改宗祠版块
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        int Update(AncestralHallItems_Model model);

        /// <summary>
        /// 删除宗祠版块通过宗祠编号(物理删除)
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        int Delete(int id);

        /// <summary>
        /// 删除宗祠版块通过宗祠编号(逻辑删除)
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        int Hidden(int id);

        /// <summary>
        /// 删除宗祠版块通过编号(物理删除)
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        int DeleteById(int id);

        /// <summary>
        /// 删除宗祠版块通过编号(逻辑删除)
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        int HiddenById(int id);


        /// <summary>
        /// 通过宗祠编号查询宗祠版块
        /// </summary>
        /// <param name="CreateId">宗祠编号</param>
        /// <param name="RequeryItems">查询的字段</param>
        /// <param name="IsDel">是否查询的被删除的信息 0:没有删除的 1:删除了的 2:所有的</param>
        /// <returns></returns>
        DataTable getAncestralHallItemsByAncestralHallId(int id, string RequeryItems, int IsDel);


        
        DataTable GetDataTable(string filter);
    }
}
